<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 16:29:54-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Port Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Available Performance</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Arrays - IOpS Capability</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(7 Day Sample)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Disk Perf with Capability" name="Combination Chart1" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																			</style>
																																		</v2_axisLabels>
																																	</v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Peak IOpS Delivered"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borders="hide" seriesType="stacked" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="IOpS Capability"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak IOpS Delivered"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:350px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Arrays - Available IOpS %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(7 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Disk Perf with Capability" name="Combination Chart2" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									</style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Available"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:350px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style>
																																							<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Pools</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Least Available %, 1 Day Sample)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart4" depth="9" refQuery="Most Active Pools">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									</style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Available IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:350px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style>
																																							<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="3"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Available IOpS Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(90 Day Sample)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Disk Perf Trends">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Available"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:540px;height:150px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Disk Utilization %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(90 Day Sample)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Disk Perf Trends" name="Combination Chart8">
																																						<v2_combinationTypeTooltips/>
																																						<v2_legend>
																																							<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_line>
																																									<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="1px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="1px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FDCF9B"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#D1B3D9"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#B8B8BF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFCCCC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:540px;height:150px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																						<v2_defaultChartMeasure refDataItem="Disk Utilization %"/></v2_combinationChart>
																																				</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-top:5px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Least Available %, 1 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Most Active Applications" name="Combination Chart5" depth="9">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borders="hide" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Available IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:350px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																									</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Least Available %, 1 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Most Active Business Units" name="Combination Chart6" depth="9">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borders="hide" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Available IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><percentFormat/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:350px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																									</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Most Active Volumes</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(1 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Most Active Volumes" name="Combination Chart10" depth="9">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borders="hide" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:355px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																									</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-top:5px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Available IOpS Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														
																														<list horizontalPagination="true" name="List2" refQuery="Detail" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Avg Volume IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Avg Volume IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Volume IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Volume IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IOpS Capability"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="IOpS Capability"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Available IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Available IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>4.2 Available Performance - ETL</reportName><queries><query name="Perf_Actual">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.avgIOpS as 'Avg IOpS Delivered',
dwh_custom.pool_perf_fact.maxIOpS as 'Peak IOpS Delivered',
dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
dwh_custom.plan_perf.planiops as 'Plan IOpS Capability'

FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId
LEFT JOIN	dwh_custom.plan_perf
ON	dwh_custom.plan_perf.controller=dwh_custom.pool_dimension.storageName 
AND 	dwh_custom.plan_perf.pool=dwh_custom.pool_dimension.storagePoolName


WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 8 DAY

GROUP by dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName

ORDER BY dwh_custom.pool_perf_fact.maxIOpS ASC LIMIT 10
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Avg IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Plan IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem label=" Peak IOpS Delivered" name="Peak IOpS Delivered" aggregate="total"><expression>[SQL1].[Peak IOpS Delivered]</expression></dataItem><dataItem aggregate="average" name="IOpS Capability"><expression>[SQL1].[IOpS Capability]</expression></dataItem><dataItem aggregate="average" name="Plan IOpS Capability"><expression>[SQL1].[Plan IOpS Capability]</expression></dataItem><dataItem name="Data Item1"><expression>[IOpS Capability]</expression></dataItem><dataItem aggregate="maximum" name="Data Item2"><expression>[IOpS Capability]</expression></dataItem></selection>
		</query><query name="Perf_Actual_Trend">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.avgIOpS as 'Avg IOpS Delivered',
dwh_custom.pool_perf_fact.maxIOpS as 'Peak IOpS Delivered',
dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
dwh_custom.plan_perf.planiops as 'Plan IOpS Capability'

FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId
LEFT JOIN	dwh_custom.plan_perf
ON	dwh_custom.plan_perf.controller=dwh_custom.pool_dimension.storageName 
AND 	dwh_custom.plan_perf.pool=dwh_custom.pool_dimension.storagePoolName


WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 365 DAY
AND dwh_custom.pool_perf_fact.repmonthorlatest=1

GROUP by dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName, dwh_custom.pool_perf_fact.fulldate </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Avg IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Plan IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem aggregate="average" name="Avg IOpS Delivered"><expression>[SQL1].[Avg IOpS Delivered]</expression></dataItem><dataItem aggregate="maximum" name="Peak IOpS Delivered"><expression>[SQL1].[Peak IOpS Delivered]</expression></dataItem><dataItem aggregate="maximum" name="IOpS Capability"><expression>[SQL1].[IOpS Capability]</expression></dataItem><dataItem aggregate="average" name="Plan IOpS Capability"><expression>[SQL1].[Plan IOpS Capability]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem></selection>
		</query><query name="Perf_Actual ALL">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.avgIOpS as 'Avg IOpS Delivered',
dwh_custom.pool_perf_fact.maxIOpS as 'Peak IOpS Delivered',
dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
dwh_custom.plan_perf.planiops as 'Plan IOpS Capability'

FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId
LEFT JOIN	dwh_custom.plan_perf
ON	dwh_custom.plan_perf.controller=dwh_custom.pool_dimension.storageName 
AND 	dwh_custom.plan_perf.pool=dwh_custom.pool_dimension.storagePoolName


WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 8 DAY

GROUP by dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Avg IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Plan IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem aggregate="maximum" label=" Peak IOpS Delivered" name="Peak IOpS Delivered"><expression>[SQL1].[Peak IOpS Delivered]</expression></dataItem><dataItem aggregate="average" name="IOpS Capability"><expression>[SQL1].[IOpS Capability]</expression></dataItem><dataItem aggregate="average" name="Plan IOpS Capability"><expression>[SQL1].[Plan IOpS Capability]</expression></dataItem><dataItem name="Data Item1"><expression>[IOpS Capability]</expression></dataItem><dataItem aggregate="maximum" name="Data Item2"><expression>[IOpS Capability]</expression></dataItem></selection>
		</query><query name="Perf_Actual Group by BU">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit) as 'Business Unit',
dwh_custom.pool_perf_fact.avgIOpS as 'Avg IOpS Delivered',
dwh_custom.pool_perf_fact.maxIOpS as 'Peak IOpS Delivered',
dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
dwh_custom.plan_perf.planiops as 'Plan IOpS Capability'

FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId
LEFT JOIN	dwh_custom.plan_perf
ON	dwh_custom.plan_perf.controller=dwh_custom.pool_dimension.storageName 
AND 	dwh_custom.plan_perf.pool=dwh_custom.pool_dimension.storagePoolName


WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 8 DAY


GROUP by IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit)
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Avg IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Plan IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem aggregate="total" name="Avg IOpS Delivered"><expression>[SQL1].[Avg IOpS Delivered]</expression></dataItem><dataItem aggregate="total" name="Peak IOpS Delivered"><expression>[SQL1].[Peak IOpS Delivered]</expression></dataItem><dataItem aggregate="average" name="IOpS Capability"><expression>[SQL1].[IOpS Capability]</expression></dataItem><dataItem aggregate="average" name="Plan IOpS Capability"><expression>[SQL1].[Plan IOpS Capability]</expression></dataItem></selection>
		</query><query name="Perf_Actual Group by Application">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.application as 'Application',
dwh_custom.pool_perf_fact.avgIOpS as 'Avg IOpS Delivered',
dwh_custom.pool_perf_fact.maxIOpS as 'Peak IOpS Delivered',
dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
dwh_custom.plan_perf.planiops as 'Plan IOpS Capability'

FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId
LEFT JOIN	dwh_custom.plan_perf
ON	dwh_custom.plan_perf.controller=dwh_custom.pool_dimension.storageName 
AND 	dwh_custom.plan_perf.pool=dwh_custom.pool_dimension.storagePoolName


WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 8 DAY


GROUP by dwh_custom.pool_perf_fact.application 
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Application"/><mdProjectedItem name="Avg IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="Plan IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem aggregate="total" name="Avg IOpS Delivered"><expression>[SQL1].[Avg IOpS Delivered]</expression></dataItem><dataItem aggregate="total" name="Peak IOpS Delivered"><expression>[SQL1].[Peak IOpS Delivered]</expression></dataItem><dataItem aggregate="average" name="IOpS Capability"><expression>[SQL1].[IOpS Capability]</expression></dataItem><dataItem aggregate="average" name="Plan IOpS Capability"><expression>[SQL1].[Plan IOpS Capability]</expression></dataItem></selection>
		</query><query name="Query1">
			<source>
				<model/>
			</source>
			<selection/>
		</query><query name="Disk Perf with Capability">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_custom.disk_perf.Array as 'Storage Name',
dwh_custom.disk_perf.PoolName as 'Pool Name',
dwh_custom.disk_perf.DiskIOPS as 'Total IOpS Delivered',
dwh_custom.disk_perf.PeakDiskIOPS as 'Peak IOpS Delivered',
dwh_custom.disk_perf.DiskUtilization as 'Disk Utilization %',
dwh_custom.disk_perf.poolIOpSCapability as 'IOpS Capability'

FROM dwh_custom.disk_perf

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Total IOpS Delivered"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Disk Utilization %"/><mdProjectedItem name="IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL2].[Pool Name]</expression></dataItem><dataItem name="Total IOpS Delivered"><expression>[SQL2].[Total IOpS Delivered]</expression></dataItem><dataItem name="Peak IOpS Delivered" aggregate="maximum"><expression>[SQL2].[Peak IOpS Delivered]</expression></dataItem><dataItem name="Disk Utilization %"><expression>[SQL2].[Disk Utilization %]</expression></dataItem><dataItem name="IOpS Capability" aggregate="maximum"><expression>[SQL2].[IOpS Capability]</expression></dataItem><dataItem name="Max IOpS For Array"><expression>maximum([Peak IOpS Delivered] for [Storage Name])</expression></dataItem><dataItem name="Max Capability for Array"><expression>maximum([IOpS Capability] for [Storage Name])</expression></dataItem><dataItem name="% Available" rollupAggregate="total" label="% Available IOpS"><expression>([Max Capability for Array]-[Max IOpS For Array])/[Max Capability for Array]</expression></dataItem></selection>
		</query><query name="Disk Perf Trends">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT     
  
diskPerf.array as 'Storage Name',
diskPerf.poolname as 'Pool Name',
diskPerf.fullDate AS 'Date',
diskPerf.totaliopsmax as 'Peak IOpS Delivered',
diskPerf.utilization AS 'Disk Utilization %',
diskPerf.poolIOpSCapability AS 'IOpS Capability'

FROM    (
SELECT
    dwh_performance.storage_dimension.name as array,
    dwh_performance.storage_dimension.datacenter as datacenter,
	dwh_performance.storage_pool_dimension.name as poolname,
        dwh_performance.date_dimension.tk dateTk,
        dwh_performance.date_dimension.fullDate fullDate,
              
        SUM(dwh_performance.disk_daily_performance_fact.totalIops) totalIops,
		SUM(dwh_performance.disk_daily_performance_fact.totalIopsmax) totalIopsmax,
        SUM(dwh_performance.disk_daily_performance_fact.readIops) readIops,
        SUM(dwh_performance.disk_daily_performance_fact.writeIops) writeIops,
        SUM(dwh_performance.disk_daily_performance_fact.totalThroughput) totalThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.readThroughput) readThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.writeThroughput) writeThroughput,
        ROUND((AVG(dwh_performance.disk_daily_performance_fact.readUtilization)/100) + (AVG(dwh_performance.disk_daily_performance_fact.writeUtilization)/100), 4) utilization,
		
			COUNT(DISTINCT dwh_inventory.disk.id) AS 'diskCount',
				
			CASE
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 4 THEN 3000
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 3 THEN 200
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 2 THEN 170
				ELSE 75
			END AS 'diskIOpSCapability',
		
				COUNT(DISTINCT dwh_inventory.disk.id) *
				(CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 4 THEN 3000
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 3 THEN 200
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 2 THEN 170
					ELSE 75
				END ) AS 'poolIopsCapability',
               
			   CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 4 THEN 'SSD'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 3 THEN 'SAS'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC' THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 2 THEN 'FC'
                     WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 1 THEN 'SATA'   
					ELSE 'Not Defined'
					END AS 'diskType',
                    MIN(dwh_inventory.disk.speed) AS 'diskSpeed',
					dwh_inventory.disk.capacityGB AS 'diskCapacityGB'
		
		
    FROM    dwh_performance.disk_daily_performance_fact
    JOIN    dwh_performance.storage_dimension
    ON  dwh_performance.disk_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
    JOIN    dwh_performance.storage_pool_dimension
    ON  dwh_performance.disk_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
    JOIN    dwh_performance.date_dimension
    ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
    AND     dwh_performance.date_dimension.fullDate &gt;= (     SELECT  MAX(dwh_performance.date_dimension.fullDate)
                                FROM    dwh_performance.disk_daily_performance_fact
                                JOIN    dwh_performance.date_dimension
                                ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk ) - INTERVAL 90 DAY
    JOIN    dwh_performance.disk_dimension
    ON  dwh_performance.disk_daily_performance_fact.diskTk = dwh_performance.disk_dimension.tk
    AND     dwh_performance.disk_dimension.role = 'DATA'
	JOIN  dwh_inventory.disk
	ON   dwh_inventory.disk.id=dwh_performance.disk_dimension.id
    GROUP BY
        dwh_performance.storage_dimension.name,
		dwh_performance.storage_pool_dimension.name,
        dwh_performance.date_dimension.fullDate
       
    ) diskPerf</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Date"/><mdProjectedItem name="Peak IOpS Delivered"/><mdProjectedItem name="Disk Utilization %"/><mdProjectedItem name="IOpS Capability"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL3].[Pool Name]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem><dataItem name="Peak IOpS Delivered" aggregate="maximum"><expression>[SQL3].[Peak IOpS Delivered]</expression></dataItem><dataItem name="Disk Utilization %" aggregate="average"><expression>[SQL3].[Disk Utilization %]</expression></dataItem><dataItem name="IOpS Capability" aggregate="maximum"><expression>[SQL3].[IOpS Capability]</expression></dataItem><dataItem name="% Available" rollupAggregate="total"><expression>1-([Peak IOpS Delivered]/[IOpS Capability])</expression></dataItem></selection>
		</query><query name="Most Active Pools">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
SUM(dwh_custom.pool_perf_fact.avgIOpS) as 'Avg Volume IOpS',
SUM(dwh_custom.pool_perf_fact.maxIOpS) as 'Peak Volume IOpS',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
IF((1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))&lt;0, 0, (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))) as '% Available IOpS'


FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 0 DAY

GROUP by dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName

HAVING (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability)) &lt; .9

ORDER BY dwh_custom.pool_dimension.storagePoolName DESC LIMIT 10
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Avg Volume IOpS"/><mdProjectedItem name="Peak Volume IOpS"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="% Available IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL4].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL4].[Pool Name]</expression></dataItem><dataItem name="Avg Volume IOpS"><expression>[SQL4].[Avg Volume IOpS]</expression></dataItem><dataItem name="Peak Volume IOpS"><expression>[SQL4].[Peak Volume IOpS]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL4].[IOpS Capability]</expression></dataItem><dataItem name="% Available IOpS" rollupAggregate="total"><expression>[SQL4].[% Available IOpS]</expression></dataItem></selection>
		</query><query name="Most Active Applications">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.storagepoolid as 'poolid',
dwh_custom.pool_perf_fact.application as 'Application',
dwh_custom.pool_perf_fact.businessunit as 'Business Unit',
SUM(dwh_custom.pool_perf_fact.avgIOpS) as 'Avg Volume IOpS',
SUM(dwh_custom.pool_perf_fact.maxIOpS) as 'Peak Volume IOpS',
-- dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
IF((1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))&lt;0, 0, (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))) as '% Available IOpS'


FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 0 DAY

GROUP by dwh_custom.pool_perf_fact.application

HAVING (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability)) &lt; .9

ORDER BY dwh_custom.pool_perf_fact.application DESC LIMIT 10


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="poolid"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Avg Volume IOpS"/><mdProjectedItem name="Peak Volume IOpS"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="% Available IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL5].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL5].[Pool Name]</expression></dataItem><dataItem name="poolid"><expression>[SQL5].[poolid]</expression></dataItem><dataItem name="Application"><expression>[SQL5].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL5].[Business Unit]</expression></dataItem><dataItem name="Avg Volume IOpS"><expression>[SQL5].[Avg Volume IOpS]</expression></dataItem><dataItem name="Peak Volume IOpS"><expression>[SQL5].[Peak Volume IOpS]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL5].[IOpS Capability]</expression></dataItem><dataItem name="% Available IOpS" rollupAggregate="total"><expression>[SQL5].[% Available IOpS]</expression></dataItem></selection>
		</query><query name="Most Active Business Units">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.storagepoolid as 'poolid',
-- dwh_custom.pool_perf_fact.application as 'Application',
dwh_custom.pool_perf_fact.businessunit as 'Business Unit',
SUM(dwh_custom.pool_perf_fact.avgIOpS) as 'Avg Volume IOpS',
SUM(dwh_custom.pool_perf_fact.maxIOpS) as 'Peak Volume IOpS',
-- dwh_custom.pool_perf_fact.fulldate as 'Full Date',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
IF((1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))&lt;0, 0, (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))) as '% Available IOpS'


FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 0 DAY

GROUP by dwh_custom.pool_perf_fact.businessunit

HAVING (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability)) &lt; .9



ORDER BY dwh_custom.pool_perf_fact.businessunit DESC LIMIT 10


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="poolid"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Avg Volume IOpS"/><mdProjectedItem name="Peak Volume IOpS"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="% Available IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL6].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL6].[Pool Name]</expression></dataItem><dataItem name="poolid"><expression>[SQL6].[poolid]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL6].[Business Unit]</expression></dataItem><dataItem name="Avg Volume IOpS"><expression>[SQL6].[Avg Volume IOpS]</expression></dataItem><dataItem name="Peak Volume IOpS"><expression>[SQL6].[Peak Volume IOpS]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL6].[IOpS Capability]</expression></dataItem><dataItem name="% Available IOpS" rollupAggregate="total"><expression>[SQL6].[% Available IOpS]</expression></dataItem></selection>
		</query><query name="Most Active Volumes">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

SUBSTRING_INDEX(dwh_custom.vol_perf_daily.volume,':',-1) as 'Volume',
dwh_custom.vol_perf_daily.totaliops as 'Total IOpS'

FROM dwh_custom.vol_perf_daily

WHERE dwh_custom.vol_perf_daily.fullDate &gt;= (SELECT MAX(dwh_custom.vol_perf_daily.fullDate) 
FROM dwh_custom.vol_perf_daily) - INTERVAL 0 DAY

ORDER BY dwh_custom.vol_perf_daily.totaliops DESC LIMIT 10
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Total IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL8].[Volume]</expression></dataItem><dataItem name="Total IOpS" rollupAggregate="total"><expression>[SQL8].[Total IOpS]</expression></dataItem></selection>
		</query><query name="Detail"><source><sqlQuery name="SQL7" dataSource="dwh_inventory" type="passThrough">
			<sqlText>select
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storagePoolName as 'Pool Name',
dwh_custom.pool_perf_fact.application as 'Application',
dwh_custom.pool_perf_fact.businessunit as 'Business Unit',
SUM(dwh_custom.pool_perf_fact.avgIOpS) as 'Avg Volume IOpS',
SUM(dwh_custom.pool_perf_fact.maxIOpS) as 'Peak Volume IOpS',
dwh_custom.pool_perf_fact.poolIopsCapability as 'IOpS Capability',
IF((1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))&lt;0, 0, (1-(SUM(dwh_custom.pool_perf_fact.maxIOpS)/dwh_custom.pool_perf_fact.poolIopsCapability))) as '% Available IOpS'


FROM 	dwh_custom.pool_perf_fact
JOIN	dwh_custom.pool_dimension
ON	dwh_custom.pool_dimension.storagePoolId=dwh_custom.pool_perf_fact.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) FROM dwh_custom.pool_perf_fact)  - INTERVAL 0 DAY

GROUP by dwh_custom.pool_dimension.storageName, dwh_custom.pool_dimension.storagePoolName, dwh_custom.pool_perf_fact.application, dwh_custom.pool_perf_fact.businessunit




</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Avg Volume IOpS"/><mdProjectedItem name="Peak Volume IOpS"/><mdProjectedItem name="IOpS Capability"/><mdProjectedItem name="% Available IOpS"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Storage Name"><expression>[SQL7].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL7].[Pool Name]</expression></dataItem><dataItem name="Application"><expression>[SQL7].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL7].[Business Unit]</expression></dataItem><dataItem name="Avg Volume IOpS"><expression>[SQL7].[Avg Volume IOpS]</expression></dataItem><dataItem name="Peak Volume IOpS"><expression>[SQL7].[Peak Volume IOpS]</expression></dataItem><dataItem name="IOpS Capability"><expression>[SQL7].[IOpS Capability]</expression></dataItem><dataItem name="% Available IOpS"><expression>[SQL7].[% Available IOpS]</expression></dataItem></selection></query></queries></report>